package com.itheima.mapper;

import com.github.pagehelper.Page;
import com.itheima.pojo.OperateLog;
import com.itheima.vo.LogVo;
import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

@Mapper
public interface OperateLogMapper {

    //插入日志数据
    @Insert("insert into operate_log (operate_user, operate_time, class_name, method_name, method_params, return_value, cost_time) " +
            "values (#{operateUser}, #{operateTime}, #{className}, #{methodName}, #{methodParams}, #{returnValue}, #{costTime});")
    public void insert(OperateLog log);

    /*分页查询日志信息*/

    @Select("select l.*, e.name operateEmpName from operate_log l left join emp e on l.operate_user = e.id")
    Page<LogVo> query();
}
